{include: include/head}
<?php
$bakdir = R('bakdir');
if(strpos($bakdir, '.', 1)) MSG('COMMON_BROWSE_0979', $bakdir);
$path = DAT.'/backup_db/'.$bakdir.'/';
if(!file_exists($path)) MSG('COMMON_BROWSE_0979', $path);
$i = R('i', 'INT');
$j = R('j', 'INT');
$k = R('k', 'INT');
$max = 4096 * 1024;
$table_str = R('table_str');
if($table_str == '') $table_str = getFile($path . '_table.txt');
$table_arr = explode(',', $table_str);
$table = $table_arr[$i];
$rs = SQL("select COUNT(*) as total from $table");
$total = $rs['total'];

if($k == 0){
    $datafile = $path .$table.'.sql';
}else{
    $datafile = $path .$table.'.'.$k.'.sql';
}

$sql = "";
$count = 0;
$limit = $total - $j;
$res = $db->query("select * from $table limit $j, $limit");
while($rs = $db->row($res)){
	$comma = '';
    $kstr = '';
    $vstr = '';
    foreach($rs as $key=>$val){
		$val = mysql_escape_string($val);
		$val = str_replace('\r', '', $val);
		$val = str_replace('\n', '', $val);
		//$kstr .= "$comma`$key`";
		$vstr .= "$comma'$val'";
		$comma = ',';
    }
    if(strlen($sql) < $max){
        $sql .= "INSERT INTO `$table` VALUES ($vstr);\n";
        $count++;
        $j++;
    }else{
        break;
    }
}

if($sql != '') putFile($datafile, $sql);

if($j < $total){
    $k++;
}else{
    $i++;
    $j=0;
    $k=0;
}

if($i >= count($table_arr)){
    delFile($path . '_table.txt');
	$return_url = "index.php?_lib=$_lib&_file=$_file";
    MSG('COMMON_0010');
}
?>
<div class="head_box">
<table width="100%" cellpadding="5" cellspacing="1">
    <tr>
    <td class="head_left"><b>{$LANG['database.backup']}</b></td>
    <td class="head_center"> </td>
    <td align="right" class="head_right"><a href="?_file={$_file}">{$LANG['database.list']}</a></td>
    </tr>
</table>
</div>

<form class="form_list" name="f1" method="post" action="?">
<div class="list_box">
<table width="100%" cellpadding="5" cellspacing="1">
    <tr><td align="center">{$LANG['database.backup']}：{$table}({$count})...</td></tr>
</table>
</div>
{__FORM()}
<input type="hidden" name="_act" value="backup" />
<input type="hidden" name="bakdir" value="{$bakdir}" />
<input type="hidden" name="i" value="{$i}" />
<input type="hidden" name="j" value="{$j}" />
<input type="hidden" name="k" value="{$k}" />
</form>
<script type="text/javascript">
	document.f1.submit();
</script>
{include: include/foot}